package com.tjmc.tiomscore.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TranPtnNelExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TranPtnNelExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andRmuidIsNull() {
            addCriterion("rmuid is null");
            return (Criteria) this;
        }

        public Criteria andRmuidIsNotNull() {
            addCriterion("rmuid is not null");
            return (Criteria) this;
        }

        public Criteria andRmuidEqualTo(String value) {
            addCriterion("rmuid =", value, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidNotEqualTo(String value) {
            addCriterion("rmuid <>", value, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidGreaterThan(String value) {
            addCriterion("rmuid >", value, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidGreaterThanOrEqualTo(String value) {
            addCriterion("rmuid >=", value, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidLessThan(String value) {
            addCriterion("rmuid <", value, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidLessThanOrEqualTo(String value) {
            addCriterion("rmuid <=", value, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidLike(String value) {
            addCriterion("rmuid like", value, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidNotLike(String value) {
            addCriterion("rmuid not like", value, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidIn(List<String> values) {
            addCriterion("rmuid in", values, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidNotIn(List<String> values) {
            addCriterion("rmuid not in", values, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidBetween(String value1, String value2) {
            addCriterion("rmuid between", value1, value2, "rmuid");
            return (Criteria) this;
        }

        public Criteria andRmuidNotBetween(String value1, String value2) {
            addCriterion("rmuid not between", value1, value2, "rmuid");
            return (Criteria) this;
        }

        public Criteria andNativenameIsNull() {
            addCriterion("nativename is null");
            return (Criteria) this;
        }

        public Criteria andNativenameIsNotNull() {
            addCriterion("nativename is not null");
            return (Criteria) this;
        }

        public Criteria andNativenameEqualTo(String value) {
            addCriterion("nativename =", value, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameNotEqualTo(String value) {
            addCriterion("nativename <>", value, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameGreaterThan(String value) {
            addCriterion("nativename >", value, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameGreaterThanOrEqualTo(String value) {
            addCriterion("nativename >=", value, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameLessThan(String value) {
            addCriterion("nativename <", value, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameLessThanOrEqualTo(String value) {
            addCriterion("nativename <=", value, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameLike(String value) {
            addCriterion("nativename like", value, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameNotLike(String value) {
            addCriterion("nativename not like", value, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameIn(List<String> values) {
            addCriterion("nativename in", values, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameNotIn(List<String> values) {
            addCriterion("nativename not in", values, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameBetween(String value1, String value2) {
            addCriterion("nativename between", value1, value2, "nativename");
            return (Criteria) this;
        }

        public Criteria andNativenameNotBetween(String value1, String value2) {
            addCriterion("nativename not between", value1, value2, "nativename");
            return (Criteria) this;
        }

        public Criteria andLocationIsNull() {
            addCriterion("location is null");
            return (Criteria) this;
        }

        public Criteria andLocationIsNotNull() {
            addCriterion("location is not null");
            return (Criteria) this;
        }

        public Criteria andLocationEqualTo(String value) {
            addCriterion("location =", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationNotEqualTo(String value) {
            addCriterion("location <>", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationGreaterThan(String value) {
            addCriterion("location >", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationGreaterThanOrEqualTo(String value) {
            addCriterion("location >=", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationLessThan(String value) {
            addCriterion("location <", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationLessThanOrEqualTo(String value) {
            addCriterion("location <=", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationLike(String value) {
            addCriterion("location like", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationNotLike(String value) {
            addCriterion("location not like", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationIn(List<String> values) {
            addCriterion("location in", values, "location");
            return (Criteria) this;
        }

        public Criteria andLocationNotIn(List<String> values) {
            addCriterion("location not in", values, "location");
            return (Criteria) this;
        }

        public Criteria andLocationBetween(String value1, String value2) {
            addCriterion("location between", value1, value2, "location");
            return (Criteria) this;
        }

        public Criteria andLocationNotBetween(String value1, String value2) {
            addCriterion("location not between", value1, value2, "location");
            return (Criteria) this;
        }

        public Criteria andProductnameIsNull() {
            addCriterion("productname is null");
            return (Criteria) this;
        }

        public Criteria andProductnameIsNotNull() {
            addCriterion("productname is not null");
            return (Criteria) this;
        }

        public Criteria andProductnameEqualTo(String value) {
            addCriterion("productname =", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotEqualTo(String value) {
            addCriterion("productname <>", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameGreaterThan(String value) {
            addCriterion("productname >", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameGreaterThanOrEqualTo(String value) {
            addCriterion("productname >=", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameLessThan(String value) {
            addCriterion("productname <", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameLessThanOrEqualTo(String value) {
            addCriterion("productname <=", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameLike(String value) {
            addCriterion("productname like", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotLike(String value) {
            addCriterion("productname not like", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameIn(List<String> values) {
            addCriterion("productname in", values, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotIn(List<String> values) {
            addCriterion("productname not in", values, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameBetween(String value1, String value2) {
            addCriterion("productname between", value1, value2, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotBetween(String value1, String value2) {
            addCriterion("productname not between", value1, value2, "productname");
            return (Criteria) this;
        }

        public Criteria andVendorIsNull() {
            addCriterion("vendor is null");
            return (Criteria) this;
        }

        public Criteria andVendorIsNotNull() {
            addCriterion("vendor is not null");
            return (Criteria) this;
        }

        public Criteria andVendorEqualTo(String value) {
            addCriterion("vendor =", value, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorNotEqualTo(String value) {
            addCriterion("vendor <>", value, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorGreaterThan(String value) {
            addCriterion("vendor >", value, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorGreaterThanOrEqualTo(String value) {
            addCriterion("vendor >=", value, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorLessThan(String value) {
            addCriterion("vendor <", value, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorLessThanOrEqualTo(String value) {
            addCriterion("vendor <=", value, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorLike(String value) {
            addCriterion("vendor like", value, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorNotLike(String value) {
            addCriterion("vendor not like", value, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorIn(List<String> values) {
            addCriterion("vendor in", values, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorNotIn(List<String> values) {
            addCriterion("vendor not in", values, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorBetween(String value1, String value2) {
            addCriterion("vendor between", value1, value2, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorNotBetween(String value1, String value2) {
            addCriterion("vendor not between", value1, value2, "vendor");
            return (Criteria) this;
        }

        public Criteria andRealityIsNull() {
            addCriterion("reality is null");
            return (Criteria) this;
        }

        public Criteria andRealityIsNotNull() {
            addCriterion("reality is not null");
            return (Criteria) this;
        }

        public Criteria andRealityEqualTo(String value) {
            addCriterion("reality =", value, "reality");
            return (Criteria) this;
        }

        public Criteria andRealityNotEqualTo(String value) {
            addCriterion("reality <>", value, "reality");
            return (Criteria) this;
        }

        public Criteria andRealityGreaterThan(String value) {
            addCriterion("reality >", value, "reality");
            return (Criteria) this;
        }

        public Criteria andRealityGreaterThanOrEqualTo(String value) {
            addCriterion("reality >=", value, "reality");
            return (Criteria) this;
        }

        public Criteria andRealityLessThan(String value) {
            addCriterion("reality <", value, "reality");
            return (Criteria) this;
        }

        public Criteria andRealityLessThanOrEqualTo(String value) {
            addCriterion("reality <=", value, "reality");
            return (Criteria) this;
        }

        public Criteria andRealityLike(String value) {
            addCriterion("reality like", value, "reality");
            return (Criteria) this;
        }

        public Criteria andRealityNotLike(String value) {
            addCriterion("reality not like", value, "reality");
            return (Criteria) this;
        }

        public Criteria andRealityIn(List<String> values) {
            addCriterion("reality in", values, "reality");
            return (Criteria) this;
        }

        public Criteria andRealityNotIn(List<String> values) {
            addCriterion("reality not in", values, "reality");
            return (Criteria) this;
        }

        public Criteria andRealityBetween(String value1, String value2) {
            addCriterion("reality between", value1, value2, "reality");
            return (Criteria) this;
        }

        public Criteria andRealityNotBetween(String value1, String value2) {
            addCriterion("reality not between", value1, value2, "reality");
            return (Criteria) this;
        }

        public Criteria andIpaddressIsNull() {
            addCriterion("ipaddress is null");
            return (Criteria) this;
        }

        public Criteria andIpaddressIsNotNull() {
            addCriterion("ipaddress is not null");
            return (Criteria) this;
        }

        public Criteria andIpaddressEqualTo(String value) {
            addCriterion("ipaddress =", value, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressNotEqualTo(String value) {
            addCriterion("ipaddress <>", value, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressGreaterThan(String value) {
            addCriterion("ipaddress >", value, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressGreaterThanOrEqualTo(String value) {
            addCriterion("ipaddress >=", value, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressLessThan(String value) {
            addCriterion("ipaddress <", value, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressLessThanOrEqualTo(String value) {
            addCriterion("ipaddress <=", value, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressLike(String value) {
            addCriterion("ipaddress like", value, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressNotLike(String value) {
            addCriterion("ipaddress not like", value, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressIn(List<String> values) {
            addCriterion("ipaddress in", values, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressNotIn(List<String> values) {
            addCriterion("ipaddress not in", values, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressBetween(String value1, String value2) {
            addCriterion("ipaddress between", value1, value2, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andIpaddressNotBetween(String value1, String value2) {
            addCriterion("ipaddress not between", value1, value2, "ipaddress");
            return (Criteria) this;
        }

        public Criteria andControlplaneipIsNull() {
            addCriterion("controlplaneip is null");
            return (Criteria) this;
        }

        public Criteria andControlplaneipIsNotNull() {
            addCriterion("controlplaneip is not null");
            return (Criteria) this;
        }

        public Criteria andControlplaneipEqualTo(String value) {
            addCriterion("controlplaneip =", value, "controlplaneip");
            return (Criteria) this;
        }

        public Criteria andControlplaneipNotEqualTo(String value) {
            addCriterion("controlplaneip <>", value, "controlplaneip");
            return (Criteria) this;
        }

        public Criteria andControlplaneipGreaterThan(String value) {
            addCriterion("controlplaneip >", value, "controlplaneip");
            return (Criteria) this;
        }

        public Criteria andControlplaneipGreaterThanOrEqualTo(String value) {
            addCriterion("controlplaneip >=", value, "controlplaneip");
            return (Criteria) this;
        }

        public Criteria andControlplaneipLessThan(String value) {
            addCriterion("controlplaneip <", value, "controlplaneip");
            return (Criteria) this;
        }

        public Criteria andControlplaneipLessThanOrEqualTo(String value) {
            addCriterion("controlplaneip <=", value, "controlplaneip");
            return (Criteria) this;
        }

        public Criteria andControlplaneipLike(String value) {
            addCriterion("controlplaneip like", value, "controlplaneip");
            return (Criteria) this;
        }

        public Criteria andControlplaneipNotLike(String value) {
            addCriterion("controlplaneip not like", value, "controlplaneip");
            return (Criteria) this;
        }

        public Criteria andControlplaneipIn(List<String> values) {
            addCriterion("controlplaneip in", values, "controlplaneip");
            return (Criteria) this;
        }

        public Criteria andControlplaneipNotIn(List<String> values) {
            addCriterion("controlplaneip not in", values, "controlplaneip");
            return (Criteria) this;
        }

        public Criteria andControlplaneipBetween(String value1, String value2) {
            addCriterion("controlplaneip between", value1, value2, "controlplaneip");
            return (Criteria) this;
        }

        public Criteria andControlplaneipNotBetween(String value1, String value2) {
            addCriterion("controlplaneip not between", value1, value2, "controlplaneip");
            return (Criteria) this;
        }

        public Criteria andHardwareversionIsNull() {
            addCriterion("hardwareversion is null");
            return (Criteria) this;
        }

        public Criteria andHardwareversionIsNotNull() {
            addCriterion("hardwareversion is not null");
            return (Criteria) this;
        }

        public Criteria andHardwareversionEqualTo(String value) {
            addCriterion("hardwareversion =", value, "hardwareversion");
            return (Criteria) this;
        }

        public Criteria andHardwareversionNotEqualTo(String value) {
            addCriterion("hardwareversion <>", value, "hardwareversion");
            return (Criteria) this;
        }

        public Criteria andHardwareversionGreaterThan(String value) {
            addCriterion("hardwareversion >", value, "hardwareversion");
            return (Criteria) this;
        }

        public Criteria andHardwareversionGreaterThanOrEqualTo(String value) {
            addCriterion("hardwareversion >=", value, "hardwareversion");
            return (Criteria) this;
        }

        public Criteria andHardwareversionLessThan(String value) {
            addCriterion("hardwareversion <", value, "hardwareversion");
            return (Criteria) this;
        }

        public Criteria andHardwareversionLessThanOrEqualTo(String value) {
            addCriterion("hardwareversion <=", value, "hardwareversion");
            return (Criteria) this;
        }

        public Criteria andHardwareversionLike(String value) {
            addCriterion("hardwareversion like", value, "hardwareversion");
            return (Criteria) this;
        }

        public Criteria andHardwareversionNotLike(String value) {
            addCriterion("hardwareversion not like", value, "hardwareversion");
            return (Criteria) this;
        }

        public Criteria andHardwareversionIn(List<String> values) {
            addCriterion("hardwareversion in", values, "hardwareversion");
            return (Criteria) this;
        }

        public Criteria andHardwareversionNotIn(List<String> values) {
            addCriterion("hardwareversion not in", values, "hardwareversion");
            return (Criteria) this;
        }

        public Criteria andHardwareversionBetween(String value1, String value2) {
            addCriterion("hardwareversion between", value1, value2, "hardwareversion");
            return (Criteria) this;
        }

        public Criteria andHardwareversionNotBetween(String value1, String value2) {
            addCriterion("hardwareversion not between", value1, value2, "hardwareversion");
            return (Criteria) this;
        }

        public Criteria andSoftwareversionIsNull() {
            addCriterion("softwareversion is null");
            return (Criteria) this;
        }

        public Criteria andSoftwareversionIsNotNull() {
            addCriterion("softwareversion is not null");
            return (Criteria) this;
        }

        public Criteria andSoftwareversionEqualTo(String value) {
            addCriterion("softwareversion =", value, "softwareversion");
            return (Criteria) this;
        }

        public Criteria andSoftwareversionNotEqualTo(String value) {
            addCriterion("softwareversion <>", value, "softwareversion");
            return (Criteria) this;
        }

        public Criteria andSoftwareversionGreaterThan(String value) {
            addCriterion("softwareversion >", value, "softwareversion");
            return (Criteria) this;
        }

        public Criteria andSoftwareversionGreaterThanOrEqualTo(String value) {
            addCriterion("softwareversion >=", value, "softwareversion");
            return (Criteria) this;
        }

        public Criteria andSoftwareversionLessThan(String value) {
            addCriterion("softwareversion <", value, "softwareversion");
            return (Criteria) this;
        }

        public Criteria andSoftwareversionLessThanOrEqualTo(String value) {
            addCriterion("softwareversion <=", value, "softwareversion");
            return (Criteria) this;
        }

        public Criteria andSoftwareversionLike(String value) {
            addCriterion("softwareversion like", value, "softwareversion");
            return (Criteria) this;
        }

        public Criteria andSoftwareversionNotLike(String value) {
            addCriterion("softwareversion not like", value, "softwareversion");
            return (Criteria) this;
        }

        public Criteria andSoftwareversionIn(List<String> values) {
            addCriterion("softwareversion in", values, "softwareversion");
            return (Criteria) this;
        }

        public Criteria andSoftwareversionNotIn(List<String> values) {
            addCriterion("softwareversion not in", values, "softwareversion");
            return (Criteria) this;
        }

        public Criteria andSoftwareversionBetween(String value1, String value2) {
            addCriterion("softwareversion between", value1, value2, "softwareversion");
            return (Criteria) this;
        }

        public Criteria andSoftwareversionNotBetween(String value1, String value2) {
            addCriterion("softwareversion not between", value1, value2, "softwareversion");
            return (Criteria) this;
        }

        public Criteria andMaxcapacityIsNull() {
            addCriterion("maxcapacity is null");
            return (Criteria) this;
        }

        public Criteria andMaxcapacityIsNotNull() {
            addCriterion("maxcapacity is not null");
            return (Criteria) this;
        }

        public Criteria andMaxcapacityEqualTo(String value) {
            addCriterion("maxcapacity =", value, "maxcapacity");
            return (Criteria) this;
        }

        public Criteria andMaxcapacityNotEqualTo(String value) {
            addCriterion("maxcapacity <>", value, "maxcapacity");
            return (Criteria) this;
        }

        public Criteria andMaxcapacityGreaterThan(String value) {
            addCriterion("maxcapacity >", value, "maxcapacity");
            return (Criteria) this;
        }

        public Criteria andMaxcapacityGreaterThanOrEqualTo(String value) {
            addCriterion("maxcapacity >=", value, "maxcapacity");
            return (Criteria) this;
        }

        public Criteria andMaxcapacityLessThan(String value) {
            addCriterion("maxcapacity <", value, "maxcapacity");
            return (Criteria) this;
        }

        public Criteria andMaxcapacityLessThanOrEqualTo(String value) {
            addCriterion("maxcapacity <=", value, "maxcapacity");
            return (Criteria) this;
        }

        public Criteria andMaxcapacityLike(String value) {
            addCriterion("maxcapacity like", value, "maxcapacity");
            return (Criteria) this;
        }

        public Criteria andMaxcapacityNotLike(String value) {
            addCriterion("maxcapacity not like", value, "maxcapacity");
            return (Criteria) this;
        }

        public Criteria andMaxcapacityIn(List<String> values) {
            addCriterion("maxcapacity in", values, "maxcapacity");
            return (Criteria) this;
        }

        public Criteria andMaxcapacityNotIn(List<String> values) {
            addCriterion("maxcapacity not in", values, "maxcapacity");
            return (Criteria) this;
        }

        public Criteria andMaxcapacityBetween(String value1, String value2) {
            addCriterion("maxcapacity between", value1, value2, "maxcapacity");
            return (Criteria) this;
        }

        public Criteria andMaxcapacityNotBetween(String value1, String value2) {
            addCriterion("maxcapacity not between", value1, value2, "maxcapacity");
            return (Criteria) this;
        }

        public Criteria andStateIsNull() {
            addCriterion("state is null");
            return (Criteria) this;
        }

        public Criteria andStateIsNotNull() {
            addCriterion("state is not null");
            return (Criteria) this;
        }

        public Criteria andStateEqualTo(String value) {
            addCriterion("state =", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotEqualTo(String value) {
            addCriterion("state <>", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThan(String value) {
            addCriterion("state >", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThanOrEqualTo(String value) {
            addCriterion("state >=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThan(String value) {
            addCriterion("state <", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThanOrEqualTo(String value) {
            addCriterion("state <=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLike(String value) {
            addCriterion("state like", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotLike(String value) {
            addCriterion("state not like", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateIn(List<String> values) {
            addCriterion("state in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotIn(List<String> values) {
            addCriterion("state not in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateBetween(String value1, String value2) {
            addCriterion("state between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotBetween(String value1, String value2) {
            addCriterion("state not between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andEmsnameIsNull() {
            addCriterion("emsname is null");
            return (Criteria) this;
        }

        public Criteria andEmsnameIsNotNull() {
            addCriterion("emsname is not null");
            return (Criteria) this;
        }

        public Criteria andEmsnameEqualTo(String value) {
            addCriterion("emsname =", value, "emsname");
            return (Criteria) this;
        }

        public Criteria andEmsnameNotEqualTo(String value) {
            addCriterion("emsname <>", value, "emsname");
            return (Criteria) this;
        }

        public Criteria andEmsnameGreaterThan(String value) {
            addCriterion("emsname >", value, "emsname");
            return (Criteria) this;
        }

        public Criteria andEmsnameGreaterThanOrEqualTo(String value) {
            addCriterion("emsname >=", value, "emsname");
            return (Criteria) this;
        }

        public Criteria andEmsnameLessThan(String value) {
            addCriterion("emsname <", value, "emsname");
            return (Criteria) this;
        }

        public Criteria andEmsnameLessThanOrEqualTo(String value) {
            addCriterion("emsname <=", value, "emsname");
            return (Criteria) this;
        }

        public Criteria andEmsnameLike(String value) {
            addCriterion("emsname like", value, "emsname");
            return (Criteria) this;
        }

        public Criteria andEmsnameNotLike(String value) {
            addCriterion("emsname not like", value, "emsname");
            return (Criteria) this;
        }

        public Criteria andEmsnameIn(List<String> values) {
            addCriterion("emsname in", values, "emsname");
            return (Criteria) this;
        }

        public Criteria andEmsnameNotIn(List<String> values) {
            addCriterion("emsname not in", values, "emsname");
            return (Criteria) this;
        }

        public Criteria andEmsnameBetween(String value1, String value2) {
            addCriterion("emsname between", value1, value2, "emsname");
            return (Criteria) this;
        }

        public Criteria andEmsnameNotBetween(String value1, String value2) {
            addCriterion("emsname not between", value1, value2, "emsname");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("updateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("updateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("updateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("updateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("updateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("updateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("updateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("updateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("updateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("updateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("updateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("updateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}